UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y8z5dX/sT7+2KTCaQrZ3cktuq+/92Yf/H8MGOONT0ro='
WHERE
key_id = '27494f350c0dd780822675353629b4bd22c8c9eecad7de161b8c76b556903bc6'
AND (
token = 'y8z5dX/sT7+2KTCaQrZ3cktuq+/92Yf/H8MGOONT0ro='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)