UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XHlQDCZeCHeCvhiCZ3cp8uKg42KJhiQTi3nW/0V6ljE='
WHERE
key_id = '6e8d3237c5345e7a5983e75f723a21aff509271142bbe9c31d65947330cfa7dc'
AND (
token = 'XHlQDCZeCHeCvhiCZ3cp8uKg42KJhiQTi3nW/0V6ljE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)