UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JZ8PYZPc/J9Yb2e8CVguVG/yNaAADhWe8V+Kt0KCpxA='
WHERE
key_id = '33a7b1e76a33922fae180d0f82c54e0a837b07faa9509bdca2325c333b52e63a'
AND (
token = 'JZ8PYZPc/J9Yb2e8CVguVG/yNaAADhWe8V+Kt0KCpxA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)