UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hxcjy1GJ9JVNWEEMdW2P1mh2H4E8uJa3B0m6ylqDleI='
WHERE
key_id = 'bc76dc91c9bc545098ad6f322fba3835b8a218d32529abac122545e5755dffba'
AND (
token = 'hxcjy1GJ9JVNWEEMdW2P1mh2H4E8uJa3B0m6ylqDleI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)