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