UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '96b80odDviiTOf+qhVF+J2xOjbiBYrh0YADLhT73+8Q='
WHERE
key_id = 'a6f3583fa25b9679c8e636af8e0090395aa422a49c11008506a93004ff57ac80'
AND (
token = '96b80odDviiTOf+qhVF+J2xOjbiBYrh0YADLhT73+8Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)