UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ohc80wwTh0No+7q+HdzvRzSWrt4pPJn/gos84PCglHo='
WHERE
key_id = '46840efc774fd5d9337b09df829333c9db7850da60fe303da6ca97b5431ed814'
AND (
token = 'ohc80wwTh0No+7q+HdzvRzSWrt4pPJn/gos84PCglHo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)