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