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