UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JzWr+JE/92UDeMcq0/FkpVt+vbyIT9BULymZXoP5BkA='
WHERE
key_id = 'b97bbe867a343440cee34727c5bd32e0675bf986d6eee07d51d82f9c5251f934'
AND (
token = 'JzWr+JE/92UDeMcq0/FkpVt+vbyIT9BULymZXoP5BkA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)