UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KJ/8V6gteae+P3+9egCe/MfuyZaHPCUdKkf026E33Ck='
WHERE
key_id = '4578f5a8d3a0400445b213f5337b8131c925654865737ab8427bc6509e54db3c'
AND (
token = 'KJ/8V6gteae+P3+9egCe/MfuyZaHPCUdKkf026E33Ck='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)