UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IV94KTScBrI7h2xQ1H3qx4mlYNxuOZhLc47N/kKbA50='
WHERE
key_id = 'a9e132d74f343ae4528f92933ae22b6a527a5ccf5df9f2ab200f71e3a95e226d'
AND (
token = 'IV94KTScBrI7h2xQ1H3qx4mlYNxuOZhLc47N/kKbA50='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)