UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9fIK3xdx36WxIOuvbRHbejO8CuKL51fK5kSBcAiF1zU='
WHERE
key_id = 'bc91a514d15df94c33bb7df4d6ee7e3696e8c5f3e9627085a81e4956784c6331'
AND (
token = '9fIK3xdx36WxIOuvbRHbejO8CuKL51fK5kSBcAiF1zU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)