UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5NDwQGcvh4aOyKeazDvh90J/nN9THQsAhfHvO72MjsQ='
WHERE
key_id = 'a28dffeab16c1d0deacce59867e27513e16f8ef49b6cf7e07be0efc6315bb9b6'
AND (
token = '5NDwQGcvh4aOyKeazDvh90J/nN9THQsAhfHvO72MjsQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)