UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4ScFgXegffdhIH9sS1YEwUSTANLFw4+lSlJFU+eOEbs='
WHERE
key_id = 'f327ee8fde9631981f6145ffffd95f3c8f19a951a2589227609a9fda54c2ab8d'
AND (
token = '4ScFgXegffdhIH9sS1YEwUSTANLFw4+lSlJFU+eOEbs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)