UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Buu+DbvHt3s3GCkyoaJUbGBMIufJyIT0qhVn/VJpnI='
WHERE
key_id = 'b4ea78b0ea050863b619290e913c854ff83293166c2f38f149b04bdf93ffe840'
AND (
token = '7Buu+DbvHt3s3GCkyoaJUbGBMIufJyIT0qhVn/VJpnI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)