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