UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VhEC6QGmXN9YRd9aG5Io1u20LWTjCA+Q1mBc/T9St+4='
WHERE
key_id = 'ffc72c77453ca650b4451bdc74917d2ff52ac70dd7c959c95bdeb11b24763990'
AND (
token = 'VhEC6QGmXN9YRd9aG5Io1u20LWTjCA+Q1mBc/T9St+4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)