UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mJiJBF4+j6NOGx8hJgZLJsMd/hRH66a8gvk6ldbzgyw='
WHERE
key_id = '27a63b97b0418ebdb89aaa4f801f33cea9947d46765713713909ae6bfb4f2cd1'
AND (
token = 'mJiJBF4+j6NOGx8hJgZLJsMd/hRH66a8gvk6ldbzgyw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)