UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XP+1jNnBf5TKkicY6xlmatSsMKL5wLoiuUSYlokX/ig='
WHERE
key_id = '7509f664dfec4691477a62593b0474ccf286ab0ad58d55bc3132cda92f49a328'
AND (
token = 'XP+1jNnBf5TKkicY6xlmatSsMKL5wLoiuUSYlokX/ig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)