UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8z8YpiEfN1qY1lDli0djBVaU9MDL58mnDDKkoWcc7Vo='
WHERE
key_id = 'e086beb979e8f3741fbc75be9a2a62caf68d6c90dfe9c8a96143b1bec0037eb5'
AND (
token = '8z8YpiEfN1qY1lDli0djBVaU9MDL58mnDDKkoWcc7Vo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)