UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N8QqJ1AoGEydRNC3lWAyCV49GwASBXFx/JtN6QBrPiA='
WHERE
key_id = '82de9ddb542483ce636078fc0fd422de5b4d95912504ff233dcaa691de174fce'
AND (
token = 'N8QqJ1AoGEydRNC3lWAyCV49GwASBXFx/JtN6QBrPiA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)