UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a7gycUcmbk7psuPybLLYqq1+MsR7HuED22ab017biZs='
WHERE
key_id = 'f4abbfffda2ec7abaf59057fb7e4bab0989b90b300bb6d8badd1ad83355de18d'
AND (
token = 'a7gycUcmbk7psuPybLLYqq1+MsR7HuED22ab017biZs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)