UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v7XqiYlk2+6uTPJ3ie16VI8wgnlZFFOx2w26B7icvfs='
WHERE
key_id = 'c6d96186fe54b8a32031473ddb8067e8c93fda692600f278185b9913ccfe00ad'
AND (
token = 'v7XqiYlk2+6uTPJ3ie16VI8wgnlZFFOx2w26B7icvfs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)