UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HRlTHlq6pjgo1VuLXijyQGEcvi8+YXK3GDvLP28vmAQ='
WHERE
key_id = 'c6f2b8e92618b82f7853022963bd9cfcd6d8802c636c0b5c3e568c75c6efde1d'
AND (
token = 'HRlTHlq6pjgo1VuLXijyQGEcvi8+YXK3GDvLP28vmAQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)