UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/ZZhgJh7UQ5zyNj7PxZnVQtG0NOWUpxLrFs7QxWvMRo='
WHERE
key_id = 'f17f6b714e043f5446903fcd72c7f0a6caa3cbd2fba194cc7282315211b2c6ab'
AND (
token = '/ZZhgJh7UQ5zyNj7PxZnVQtG0NOWUpxLrFs7QxWvMRo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)