UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WtwhMWbwA46AqXk7/O/1RAx+QCQYRqT2txQ3NN8ImkY='
WHERE
key_id = '52dd2f13b53add0320e43a3449963bddb6a6f116c479a432fcc509cc4904e7b1'
AND (
token = 'WtwhMWbwA46AqXk7/O/1RAx+QCQYRqT2txQ3NN8ImkY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)